Tabela LContractOrgUnitAccount

Definicja tabeli LContractOrgUnitAccount

Name

LContractOrgUnitAccount

Code

LContractOrgUnitAccount

Comment

Powiazanie jednostki organizacyjnej oraz kontraktu z numerem konta z planu kont


Lista kolumn tabeli LContractOrgUnitAccount

Name

Code

LContractOrgUnitAccountID

LContractOrgUnitAccountID

ContractID

ContractID

AccountID

AccountID

Active

Active

AccountNumber

AccountNumber

StartDT

StartDT

StopDT

StopDT


Kolumna LContractOrgUnitAccountID tabeli LContractOrgUnitAccount

Definicja kolumny LContractOrgUnitAccountID tabeli LContractOrgUnitAccount

Name

LContractOrgUnitAccountID

Code

LContractOrgUnitAccountID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

ID powiazania jednostki organizacyjnej oraz kontraktu z numerem konta z planu kont


Kolumna ContractID tabeli LContractOrgUnitAccount

Definicja kolumny ContractID tabeli LContractOrgUnitAccount

Name

ContractID

Code

ContractID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

ID umowy


Kolumna AccountID tabeli LContractOrgUnitAccount

Definicja kolumny AccountID tabeli LContractOrgUnitAccount

Name

AccountID

Code

AccountID

Data Type

NUMBER(10)

Mandatory

No

Comment

ID konta


Kolumna Active tabeli LContractOrgUnitAccount

Definicja kolumny Active tabeli LContractOrgUnitAccount

Name

Active

Code

Active

Data Type

NUMBER(5)

Mandatory

No

Comment

PL: Aktywnosc wiersza.
EN: Record's Activity
DE: Aktivitat des Rekord


Kolumna AccountNumber tabeli LContractOrgUnitAccount

Definicja kolumny AccountNumber tabeli LContractOrgUnitAccount

Name

AccountNumber

Code

AccountNumber

Data Type

VARCHAR2(128)

Mandatory

No

Comment

Nr konta ksiegowego z planu kont


Kolumna StartDT tabeli LContractOrgUnitAccount

Definicja kolumny StartDT tabeli LContractOrgUnitAccount

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

No

Comment

PL: Data poczatku
EN: Start date
DE: das Beginndatum


Kolumna StopDT tabeli LContractOrgUnitAccount

Definicja kolumny StopDT tabeli LContractOrgUnitAccount

Name

StopDT

Code

StopDT

Data Type

DATE

Mandatory

No

Comment

PL: Data koncowa
EN: Stop date
DE: Das Endedatum


Lista kluczy tabeli LContractOrgUnitAccount

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli LContractOrgUnitAccount

Definicja klucza Identifier_1 tabeli LContractOrgUnitAccount

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment